Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# EXISTS Condition

An `EXISTS` condition tests for existence of rows in a subquery.

Description of the illustration exists_condition.gif

Table 7-11 shows the `EXISTS` condition.

Table 7-11 EXISTS Condition ``

Type of Condition | Operation | Example
--- | --- | ---
    EXISTS
| `TRUE` if a subquery returns at least one row. |
    SELECT department_id
      FROM departments d
      WHERE EXISTS
      (SELECT * FROM employees e
        WHERE d.department_id
        = e.department_id);